SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].gspFileAttach_UPDATE
(
@fileAttachId int = null,
@name nvarchar(128) = null,
@mimeType nvarchar(128) = null,
@fileSize int = null,
@description nvarchar(256) = null,
@createdDate datetime = null,
@lastModifiedDate datetime = null,
@isDeleted bit = null
)
AS

UPDATE
  [dbo].[FileAttach]
SET
  [Name] = @name,
  [MimeType] = @mimeType,
  [FileSize] = @fileSize,
  [Description] = @description,
  [CreatedDate] = @createdDate,
  [LastModifiedDate] = @lastModifiedDate,
  [IsDeleted] = @isDeleted
WHERE
  [FileAttachId] = @fileAttachId


GO
